/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50709
 Source Host           : 127.0.0.1
 Source Database       : dt

 Target Server Type    : MySQL
 Target Server Version : 50709
 File Encoding         : utf-8

 Date: 05/29/2016 22:16:28 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `cms_company`
-- ----------------------------
DROP TABLE IF EXISTS `cms_company`;
CREATE TABLE `cms_company` (
  `id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(20) NOT NULL COMMENT '用户名',
  `pass_word` varchar(50) NOT NULL COMMENT '密码',
  `role` tinyint(2) NOT NULL COMMENT '角色',
  `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态(1:可用;0不可用)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='公司表';

-- ----------------------------
--  Records of `cms_company`
-- ----------------------------
BEGIN;
INSERT INTO `cms_company` VALUES ('1', '13803743156', '5ceb4178d153f24414232389d8286fdf ', '0', '1');
COMMIT;

-- ----------------------------
--  Table structure for `cms_customer`
-- ----------------------------
DROP TABLE IF EXISTS `cms_customer`;
CREATE TABLE `cms_customer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(10) NOT NULL DEFAULT '' COMMENT '名称',
  `mobile` varchar(20) NOT NULL DEFAULT '' COMMENT '手机号',
  `address` varchar(255) NOT NULL DEFAULT '' COMMENT '地址',
  `balance` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '余额',
  `discount` tinyint(3) NOT NULL DEFAULT '100' COMMENT '折扣',
  `company_id` tinyint(2) NOT NULL DEFAULT '1' COMMENT '公司id',
  `is_delete` tinyint(2) NOT NULL DEFAULT '0' COMMENT '是否删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='顾客表';

-- ----------------------------
--  Records of `cms_customer`
-- ----------------------------
BEGIN;
INSERT INTO `cms_customer` VALUES ('1', '董涛', '18101332343', '北京', '0.00', '98', '1', '0'), ('2', '任红亮', '13803743156', '禹州', '2000.00', '98', '1', '1');
COMMIT;

-- ----------------------------
--  Table structure for `cms_order`
-- ----------------------------
DROP TABLE IF EXISTS `cms_order`;
CREATE TABLE `cms_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_no` varchar(50) NOT NULL COMMENT '订单号',
  `order_name` varchar(50) NOT NULL COMMENT '订单名称',
  `order_desc` text NOT NULL COMMENT '订单描述',
  `cus_id` int(11) NOT NULL COMMENT '顾客id',
  `cus_mobile` varchar(20) NOT NULL COMMENT '客户手机号',
  `cus_name` varchar(10) NOT NULL COMMENT '客户姓名',
  `cus_address` varchar(155) NOT NULL COMMENT '客户地址',
  `cus_discount` tinyint(3) NOT NULL COMMENT '客户折扣',
  `com_id` tinyint(4) NOT NULL DEFAULT '1' COMMENT '公司id',
  `pro_count` tinyint(4) NOT NULL COMMENT '产品总数',
  `exp_charge` decimal(5,2) NOT NULL COMMENT '快递费',
  `ori_price` decimal(10,2) NOT NULL COMMENT '原价',
  `price` decimal(10,2) NOT NULL COMMENT '实际价格',
  `create_date` int(11) NOT NULL COMMENT '创建日期',
  `is_delete` tinyint(2) NOT NULL COMMENT '删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='订单表';

-- ----------------------------
--  Records of `cms_order`
-- ----------------------------
BEGIN;
INSERT INTO `cms_order` VALUES ('3', '123', '董涛-订单-2016-04-17 14:52', '[{\"id\":\"1\",\"name\":\"\\u9ed1\\u68d5\",\"price\":\"180.00\",\"count\":\"1\",\"money\":180},{\"id\":\"32\",\"name\":\"\\u5507\\u90e8\\u5957\\u76d2\",\"price\":\"680.00\",\"count\":\"1\",\"money\":680},{\"id\":\"33\",\"name\":\"\\u5355\\u9488(20\\u6839)\",\"price\":\"10.00\",\"count\":\"2\",\"money\":20},{\"id\":\"3\",\"name\":\"\\u68d5\\u8272\",\"price\":\"180.00\",\"count\":\"1\",\"money\":180}]', '1', '18101332343', '董涛', '北京', '98', '1', '5', '10.00', '1060.00', '1038.80', '1460875944', '0'), ('4', '123', '董涛-订单-2016-04-17 17:17', '[{\"id\":\"1\",\"name\":\"\\u9ed1\\u68d5\",\"price\":\"180.00\",\"count\":\"1\",\"money\":180},{\"id\":\"32\",\"name\":\"\\u5507\\u90e8\\u5957\\u76d2\",\"price\":\"680.00\",\"count\":\"1\",\"money\":680},{\"id\":\"2\",\"name\":\"\\u6df1\\u68d5\",\"price\":\"180.00\",\"count\":\"1\",\"money\":180},{\"id\":\"3\",\"name\":\"\\u68d5\\u8272\",\"price\":\"180.00\",\"count\":\"2\",\"money\":360},{\"id\":\"4\",\"name\":\"\\u6d53\\u7f29\\u81ea\\u7136\\u7070\",\"price\":\"220.00\",\"count\":\"2\",\"money\":440},{\"id\":\"5\",\"name\":\"\\u6d53\\u7f29\\u9ed1\\u7070\",\"price\":\"220.00\",\"count\":\"1\",\"money\":220},{\"id\":\"6\",\"name\":\"\\u6d53\\u7f29\\u6d45\\u7070\",\"price\":\"220.00\",\"count\":\"1\",\"money\":220},{\"id\":\"37\",\"name\":\"\\u5f2f\\u5f2f\\u7ee310\\u7247\",\"price\":\"70.00\",\"count\":\"1\",\"money\":70},{\"id\":\"7\",\"name\":\"\\u6d53\\u7f29\\u571f\\u9ec4\",\"price\":\"220.00\",\"count\":\"1\",\"money\":220},{\"id\":\"8\",\"name\":\"\\u571f\\u9ec4\",\"price\":\"180.00\",\"count\":\"1\",\"money\":180},{\"id\":\"41\",\"name\":\"\\u7eb9\\u9970\\u8212\\u7f13\\u818f(20\\u514b\\/\\u74f6)\",\"price\":\"100.00\",\"count\":\"1\",\"money\":100},{\"id\":\"11\",\"name\":\"\\u6d53\\u7f29\\u80a4\\u8272\",\"price\":\"220.00\",\"count\":\"1\",\"money\":220}]', '1', '18101332343', '董涛', '北京', '98', '1', '14', '10.00', '3070.00', '3008.60', '1460884656', '1'), ('5', '123', '董涛-订单-2016-04-17 23:14', '[{\"id\":\"1\",\"name\":\"\\u9ed1\\u68d5\",\"price\":\"180.00\",\"count\":\"1\",\"money\":180},{\"id\":\"2\",\"name\":\"\\u6df1\\u68d5\",\"price\":\"180.00\",\"count\":\"1\",\"money\":180}]', '1', '18101332343', '董涛', '北京', '98', '1', '2', '10.00', '360.00', '352.80', '1460906074', '1'), ('6', '123', '董涛-订单-2016-04-17 23:18', '[{\"id\":\"1\",\"name\":\"\\u9ed1\\u68d5\",\"price\":\"180.00\",\"count\":\"1\",\"money\":180}]', '1', '18101332343', '董涛', '北京', '98', '1', '1', '10.00', '180.00', '176.40', '1460906282', '1');
COMMIT;

-- ----------------------------
--  Table structure for `cms_product`
-- ----------------------------
DROP TABLE IF EXISTS `cms_product`;
CREATE TABLE `cms_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_name` varchar(50) NOT NULL DEFAULT '' COMMENT '产品名称',
  `price` decimal(10,2) NOT NULL COMMENT '价格',
  `count` int(11) NOT NULL COMMENT '库存',
  `is_delete` tinyint(2) NOT NULL COMMENT '删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8 COMMENT='产品表';

-- ----------------------------
--  Records of `cms_product`
-- ----------------------------
BEGIN;
INSERT INTO `cms_product` VALUES ('1', '黑棕', '180.00', '14', '0'), ('2', '深棕', '180.00', '36', '0'), ('3', '棕色', '180.00', '37', '0'), ('4', '浓缩自然灰', '220.00', '50', '0'), ('5', '浓缩黑灰', '220.00', '41', '0'), ('6', '浓缩浅灰', '220.00', '48', '0'), ('7', '浓缩土黄', '220.00', '50', '0'), ('8', '土黄', '180.00', '42', '0'), ('9', '浓缩墨黑', '220.00', '46', '0'), ('10', '亮黑色', '180.00', '40', '0'), ('11', '浓缩肤色', '220.00', '39', '0'), ('12', '浓缩深红', '220.00', '46', '0'), ('13', '浓缩大红', '220.00', '50', '0'), ('14', '浓缩艳红', '220.00', '50', '0'), ('15', '浓缩桔红', '220.00', '49', '0'), ('16', '浓缩绿棕', '220.00', '50', '0'), ('17', '浓缩酒红', '220.00', '50', '0'), ('18', '肤色', '180.00', '50', '0'), ('19', '橘红', '180.00', '50', '0'), ('20', '番茄红', '180.00', '50', '0'), ('21', '石榴红', '180.00', '50', '0'), ('22', '桃花粉', '180.00', '50', '0'), ('23', '红唇妆 2#', '180.00', '46', '0'), ('24', '西瓜红', '120.00', '50', '0'), ('25', '草莓红', '120.00', '50', '0'), ('26', '转色红', '120.00', '50', '0'), ('27', '眉唇宝', '5.00', '47', '0'), ('28', '唇部祛角质', '60.00', '45', '0'), ('29', '护色凝胶', '80.00', '50', '0'), ('30', '唇部清洁液', '40.00', '50', '0'), ('31', '眉眼套盒', '680.00', '50', '0'), ('32', '唇部套盒', '680.00', '30', '0'), ('33', '单针(20根)', '10.00', '46', '0'), ('34', '三针(10根)', '40.00', '44', '0'), ('35', '5排针(10片)', '50.00', '48', '0'), ('36', '飘眉针片1片', '6.00', '49', '0'), ('37', '弯弯绣10片', '70.00', '49', '0'), ('38', '单针针帽5个', '4.00', '46', '0'), ('39', '三针针帽5个', '4.00', '50', '0'), ('40', '五排针针帽5个', '4.00', '47', '0'), ('41', '纹饰舒缓膏(20克/瓶)', '100.00', '40', '0'), ('42', '纹前辅助液', '120.00', '50', '0'), ('43', '纹中增亮辅助液', '120.00', '50', '0'), ('44', '纹饰舒缓膏(10克/瓶)', '50.00', '50', '0'), ('45', '眉部修复精华', '10.00', '50', '0'), ('46', '唇部修复精华', '15.00', '50', '0'), ('47', '唇宝', '25.00', '50', '0'), ('48', '增量宝', '29.00', '50', '0'), ('49', '晶透亮唇精华', '30.00', '50', '0'), ('50', '刚伦纹饰机', '860.00', '50', '0'), ('51', '土豪金纹饰仪', '1800.00', '50', '0'), ('52', '纹绣笔', '80.00', '50', '0'), ('53', '练习皮', '20.00', '50', '0'), ('54', '一次性美容包', '30.00', '50', '0'), ('55', '疤痕修复膏', '68.00', '50', '0'), ('56', '色料戒指(25个/包)', '8.00', '49', '0'), ('57', '雾眉笔', '90.00', '50', '0'), ('58', '雾眉圆五针(10)根', '50.00', '50', '0'), ('59', '纹绣书', '268.00', '50', '0'), ('60', '塑料碗(20个)', '10.00', '50', '0'), ('61', '水晶座', '20.00', '50', '0'), ('62', '粉雾眉套盒', '168.00', '50', '0');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
